package cj.web.portal.dao;
/*
 *  
 *  
*/
import java.util.List;
import java.util.Map;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.SQL;

/**
 * 
 * @author HanMin
 *
 * 2015年12月29日
 */
@DAO
public interface HomeDAO{
	
	//列表
	@SQL("SELECT id,title,category,abstractInfor,carouselImage,releaseAT,source FROM Contant WHERE deleteFlag=1 and category in (:1) ORDER BY stickAT DESC,updateAT DESC LIMIT :2,:3 ")
    List<Map> queryByInCategory(List<String> category,int start,int length);
	
	//列表
	@SQL("SELECT id,title,category,abstractInfor,carouselImage,releaseAT,source FROM Contant WHERE deleteFlag=1 #if(:1!=''){AND category = :1 } ORDER BY stickAT DESC,updateAT DESC LIMIT :2,:3 ")
    List<Map> query(String category,int start,int length);
}